using HKB.Common;
using System;
using System.CodeDom.Compiler;
using System.ComponentModel;
using System.ComponentModel.Design;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Diagnostics;
namespace HKB.Data.Dal.S_IndexArticleTableAdapters
{
	[GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0"), DataObject(true), HelpKeyword("vs.data.TableAdapter"), Designer("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"), DesignerCategory("code"), ToolboxItem(true)]
	public class HLShop_IndexArticleTableAdapter : Component
	{
		private SqlDataAdapter _adapter;
		private SqlConnection _connection;
		private SqlCommand[] _commandCollection;
		private bool _clearBeforeFill;
		[System.Diagnostics.DebuggerNonUserCode]
		private SqlDataAdapter Adapter
		{
			get
			{
				if (this._adapter == null)
				{
					this.InitAdapter();
				}
				return this._adapter;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		internal SqlConnection Connection
		{
			get
			{
				if (this._connection == null)
				{
					this.InitConnection();
				}
				return this._connection;
			}
			set
			{
				this._connection = value;
				if (this.Adapter.InsertCommand != null)
				{
					this.Adapter.InsertCommand.Connection = value;
				}
				if (this.Adapter.DeleteCommand != null)
				{
					this.Adapter.DeleteCommand.Connection = value;
				}
				if (this.Adapter.UpdateCommand != null)
				{
					this.Adapter.UpdateCommand.Connection = value;
				}
				for (int i = 0; i < this.CommandCollection.Length; i++)
				{
					if (this.CommandCollection[i] != null)
					{
						this.CommandCollection[i].Connection = value;
					}
				}
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		protected SqlCommand[] CommandCollection
		{
			get
			{
				if (this._commandCollection == null)
				{
					this.InitCommandCollection();
				}
				return this._commandCollection;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public bool ClearBeforeFill
		{
			get
			{
				return this._clearBeforeFill;
			}
			set
			{
				this._clearBeforeFill = value;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public HLShop_IndexArticleTableAdapter()
		{
			this.ClearBeforeFill = true;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitAdapter()
		{
			this._adapter = new SqlDataAdapter();
			DataTableMapping dataTableMapping = new DataTableMapping();
			dataTableMapping.SourceTable = "Table";
			dataTableMapping.DataSetTable = "HLShop_IndexArticle";
			dataTableMapping.ColumnMappings.Add("ArticleID", "ArticleID");
			dataTableMapping.ColumnMappings.Add("ChannelID", "ChannelID");
			dataTableMapping.ColumnMappings.Add("ClassID", "ClassID");
			dataTableMapping.ColumnMappings.Add("ArticleType", "ArticleType");
			dataTableMapping.ColumnMappings.Add("TitleType", "TitleType");
			dataTableMapping.ColumnMappings.Add("ShortTitle", "ShortTitle");
			dataTableMapping.ColumnMappings.Add("LognTitle", "LognTitle");
			dataTableMapping.ColumnMappings.Add("ArticleContent", "ArticleContent");
			dataTableMapping.ColumnMappings.Add("LinkUrl", "LinkUrl");
			dataTableMapping.ColumnMappings.Add("TitleLength", "TitleLength");
			dataTableMapping.ColumnMappings.Add("PicUrl", "PicUrl");
			dataTableMapping.ColumnMappings.Add("IncludePic", "IncludePic");
			dataTableMapping.ColumnMappings.Add("InputTime", "InputTime");
			dataTableMapping.ColumnMappings.Add("UpdateTime", "UpdateTime");
			dataTableMapping.ColumnMappings.Add("Hits", "Hits");
			dataTableMapping.ColumnMappings.Add("Editor", "Editor");
			dataTableMapping.ColumnMappings.Add("Elite", "Elite");
			dataTableMapping.ColumnMappings.Add("ArticleUserID", "ArticleUserID");
			dataTableMapping.ColumnMappings.Add("Validay", "Validay");
			dataTableMapping.ColumnMappings.Add("Status", "Status");
			dataTableMapping.ColumnMappings.Add("SpecialID", "SpecialID");
			dataTableMapping.ColumnMappings.Add("OnTop", "OnTop");
			dataTableMapping.ColumnMappings.Add("UploadPicUrl", "UploadPicUrl");
			dataTableMapping.ColumnMappings.Add("IsHighDisplay", "IsHighDisplay");
			dataTableMapping.ColumnMappings.Add("LinkType", "LinkType");
			dataTableMapping.ColumnMappings.Add("TemplatePath", "TemplatePath");
			dataTableMapping.ColumnMappings.Add("summary", "summary");
			this._adapter.TableMappings.Add(dataTableMapping);
			this._adapter.DeleteCommand = new SqlCommand();
			this._adapter.DeleteCommand.Connection = this.Connection;
			this._adapter.DeleteCommand.CommandText = "DELETE FROM [HLShop_IndexArticle] WHERE (([ArticleID] = @Original_ArticleID))";
			this._adapter.DeleteCommand.CommandType = CommandType.Text;
			this._adapter.DeleteCommand.Parameters.Add(new SqlParameter("@Original_ArticleID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ArticleID", DataRowVersion.Original, false, null, "", "", ""));
			this._adapter.InsertCommand = new SqlCommand();
			this._adapter.InsertCommand.Connection = this.Connection;
			this._adapter.InsertCommand.CommandText = "INSERT INTO [HLShop_IndexArticle] ([ChannelID], [ClassID], [ArticleType], [TitleType], [ShortTitle], [LognTitle], [ArticleContent], [LinkUrl], [TitleLength], [PicUrl], [IncludePic], [InputTime], [UpdateTime], [Hits], [Editor], [Elite], [ArticleUserID], [Validay], [Status], [SpecialID], [OnTop], [UploadPicUrl], [IsHighDisplay], [LinkType], [TemplatePath], [summary]) VALUES (@ChannelID, @ClassID, @ArticleType, @TitleType, @ShortTitle, @LognTitle, @ArticleContent, @LinkUrl, @TitleLength, @PicUrl, @IncludePic, @InputTime, @UpdateTime, @Hits, @Editor, @Elite, @ArticleUserID, @Validay, @Status, @SpecialID, @OnTop, @UploadPicUrl, @IsHighDisplay, @LinkType, @TemplatePath, @summary)";
			this._adapter.InsertCommand.CommandType = CommandType.Text;
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ChannelID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ChannelID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ArticleType", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ArticleType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TitleType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TitleType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShortTitle", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ShortTitle", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@LognTitle", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "LognTitle", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ArticleContent", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "ArticleContent", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@LinkUrl", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "LinkUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TitleLength", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TitleLength", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PicUrl", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "PicUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@IncludePic", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "IncludePic", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@InputTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "InputTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@UpdateTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "UpdateTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Hits", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Hits", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Editor", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Editor", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Elite", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Elite", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ArticleUserID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ArticleUserID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Validay", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Validay", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Status", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Status", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@SpecialID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SpecialID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OnTop", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OnTop", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@UploadPicUrl", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "UploadPicUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@IsHighDisplay", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "IsHighDisplay", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@LinkType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "LinkType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TemplatePath", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "TemplatePath", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@summary", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "summary", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand = new SqlCommand();
			this._adapter.UpdateCommand.Connection = this.Connection;
			this._adapter.UpdateCommand.CommandText = "UPDATE [HLShop_IndexArticle] SET [ChannelID] = @ChannelID, [ClassID] = @ClassID, [ArticleType] = @ArticleType, [TitleType] = @TitleType, [ShortTitle] = @ShortTitle, [LognTitle] = @LognTitle, [ArticleContent] = @ArticleContent, [LinkUrl] = @LinkUrl, [TitleLength] = @TitleLength, [PicUrl] = @PicUrl, [IncludePic] = @IncludePic, [InputTime] = @InputTime, [UpdateTime] = @UpdateTime, [Hits] = @Hits, [Editor] = @Editor, [Elite] = @Elite, [ArticleUserID] = @ArticleUserID, [Validay] = @Validay, [Status] = @Status, [SpecialID] = @SpecialID, [OnTop] = @OnTop, [UploadPicUrl] = @UploadPicUrl, [IsHighDisplay] = @IsHighDisplay, [LinkType] = @LinkType, [TemplatePath] = @TemplatePath, [summary] = @summary WHERE (([ArticleID] = @Original_ArticleID))";
			this._adapter.UpdateCommand.CommandType = CommandType.Text;
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ChannelID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ChannelID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ArticleType", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ArticleType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TitleType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TitleType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShortTitle", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ShortTitle", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@LognTitle", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "LognTitle", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ArticleContent", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "ArticleContent", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@LinkUrl", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "LinkUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TitleLength", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TitleLength", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PicUrl", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "PicUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@IncludePic", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "IncludePic", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@InputTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "InputTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@UpdateTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "UpdateTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Hits", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Hits", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Editor", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Editor", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Elite", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Elite", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ArticleUserID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ArticleUserID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Validay", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Validay", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Status", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Status", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@SpecialID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SpecialID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OnTop", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OnTop", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@UploadPicUrl", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "UploadPicUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@IsHighDisplay", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "IsHighDisplay", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@LinkType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "LinkType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TemplatePath", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "TemplatePath", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@summary", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "summary", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Original_ArticleID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ArticleID", DataRowVersion.Original, false, null, "", "", ""));
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitConnection()
		{
			this._connection = new SqlConnection();
			this._connection.ConnectionString = Conn.CurrenConnectionStrings;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitCommandCollection()
		{
			this._commandCollection = new SqlCommand[11];
			this._commandCollection[0] = new SqlCommand();
			this._commandCollection[0].Connection = this.Connection;
			this._commandCollection[0].CommandText = "SELECT ChannelID, ClassID, ArticleType, TitleType, ShortTitle, LognTitle, ArticleContent, \r\n      LinkUrl, TitleLength, PicUrl, IncludePic, InputTime, UpdateTime, Hits, Editor, Elite, \r\n      ArticleUserID, Validay, Status, ArticleID, SpecialID, OnTop, UploadPicUrl, \r\n      IsHighDisplay, LinkType, TemplatePath, summary\r\nFROM HLShop_IndexArticle\r\nORDER BY ArticleID DESC";
			this._commandCollection[0].CommandType = CommandType.Text;
			this._commandCollection[1] = new SqlCommand();
			this._commandCollection[1].Connection = this.Connection;
			this._commandCollection[1].CommandText = "INSERT INTO HLShop_IndexArticle\r\n      (ChannelID, ClassID, ArticleType, TitleType, ShortTitle, LognTitle, ArticleContent, \r\n      LinkUrl, TitleLength, PicUrl, IncludePic, InputTime, UpdateTime, Hits, Editor, OnTop, \r\n      Elite, ArticleUserID, Validay, Status, SpecialID, TemplatePath)\r\nVALUES (@ChannelID,@ClassID,@ArticleType,@TitleType,@ShortTitle,@LognTitle,@ArticleContent,@LinkUrl,@TitleLength,@PicUrl,@IncludePic,@InputTime,@UpdateTime,@Hits,@Editor,@OnTop,@Elite,@ArticleUserID,@Validay,@Status,@SpecialID,@TemplatePath)";
			this._commandCollection[1].CommandType = CommandType.Text;
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ChannelID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ChannelID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ArticleType", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "ArticleType", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TitleType", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TitleType", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ShortTitle", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "ShortTitle", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@LognTitle", SqlDbType.VarChar, 200, ParameterDirection.Input, 0, 0, "LognTitle", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ArticleContent", SqlDbType.Text, 2147483647, ParameterDirection.Input, 0, 0, "ArticleContent", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@LinkUrl", SqlDbType.VarChar, 300, ParameterDirection.Input, 0, 0, "LinkUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TitleLength", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TitleLength", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PicUrl", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, "PicUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@IncludePic", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "IncludePic", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@InputTime", SqlDbType.DateTime, 8, ParameterDirection.Input, 0, 0, "InputTime", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@UpdateTime", SqlDbType.DateTime, 8, ParameterDirection.Input, 0, 0, "UpdateTime", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Hits", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "Hits", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Editor", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "Editor", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@OnTop", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "OnTop", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Elite", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "Elite", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ArticleUserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ArticleUserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Validay", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "Validay", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Status", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "Status", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@SpecialID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SpecialID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TemplatePath", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, "TemplatePath", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2] = new SqlCommand();
			this._commandCollection[2].Connection = this.Connection;
			this._commandCollection[2].CommandText = "PR_PageListForAdmin";
			this._commandCollection[2].CommandType = CommandType.StoredProcedure;
			this._commandCollection[2].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@tblName", SqlDbType.VarChar, 255, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@strGetFields", SqlDbType.VarChar, 1000, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@fldName", SqlDbType.VarChar, 255, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@PageSize", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@PageIndex", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@OrderType", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@strWhere", SqlDbType.VarChar, 1500, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@Counts", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[3] = new SqlCommand();
			this._commandCollection[3].Connection = this.Connection;
			this._commandCollection[3].CommandText = "SELECT HLShop_IndexArticle.*, \r\n      HLShop_Module.Title, HLShop_Module.id,HLShop_Module.Layout\r\nFROM HLShop_IndexArticle INNER JOIN\r\n      HLShop_Module ON HLShop_IndexArticle.ChannelID = HLShop_Module.id\r\nWHERE (HLShop_IndexArticle.ArticleID = @ArticleID)";
			this._commandCollection[3].CommandType = CommandType.Text;
			this._commandCollection[3].Parameters.Add(new SqlParameter("@ArticleID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ArticleID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[4] = new SqlCommand();
			this._commandCollection[4].Connection = this.Connection;
			this._commandCollection[4].CommandText = "\r\n                      SELECT ChannelID, ClassID, ArticleType, TitleType, ShortTitle, LognTitle, \r\n                      LinkUrl, TitleLength, PicUrl, IncludePic, InputTime, UpdateTime, Hits, Editor, Elite,\r\n                      ArticleUserID, Validay, Status, ArticleID, SpecialID, OnTop, UploadPicUrl,\r\n                      IsHighDisplay, LinkType\r\n                      FROM HLShop_IndexArticle\r\n                      WHERE ChannelID=@ChannelID and Status=3\r\n                      ORDER BY TitleType asc,ArticleID DESC";
			this._commandCollection[4].CommandType = CommandType.Text;
			this._commandCollection[4].Parameters.Add(new SqlParameter("@ChannelID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ChannelID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[5] = new SqlCommand();
			this._commandCollection[5].Connection = this.Connection;
			this._commandCollection[5].CommandText = "\r\n                      SELECT ChannelID, ClassID, ArticleType, TitleType, ShortTitle, LognTitle, ArticleContent,\r\n                      LinkUrl, TitleLength, PicUrl, IncludePic, InputTime, UpdateTime, Hits, Editor, Elite,\r\n                      ArticleUserID, Validay, Status, ArticleID, SpecialID, OnTop, UploadPicUrl,\r\n                      IsHighDisplay, LinkType\r\n                      FROM HLShop_IndexArticle\r\n                      WHERE ChannelID=@ChannelID and Status=3 and SpecialID=@SpecialID\r\n                      ORDER BY ArticleID DESC";
			this._commandCollection[5].CommandType = CommandType.Text;
			this._commandCollection[5].Parameters.Add(new SqlParameter("@ChannelID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ChannelID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[5].Parameters.Add(new SqlParameter("@SpecialID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SpecialID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6] = new SqlCommand();
			this._commandCollection[6].Connection = this.Connection;
			this._commandCollection[6].CommandText = "SELECT ChannelID, ClassID, ArticleType, TitleType, ShortTitle, LognTitle, ArticleContent, \r\n      LinkUrl, TitleLength, PicUrl, IncludePic, InputTime, UpdateTime, Hits, Editor, Elite, \r\n      ArticleUserID, Validay, Status, ArticleID, SpecialID, OnTop\r\nFROM HLShop_IndexArticle where SpecialID=@SpecialID and ArticleType=@ArticleType\r\nORDER BY ArticleID DESC";
			this._commandCollection[6].CommandType = CommandType.Text;
			this._commandCollection[6].Parameters.Add(new SqlParameter("@SpecialID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SpecialID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6].Parameters.Add(new SqlParameter("@ArticleType", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "ArticleType", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7] = new SqlCommand();
			this._commandCollection[7].Connection = this.Connection;
			this._commandCollection[7].CommandText = "SELECT ChannelID, ClassID, ArticleType, TitleType, ShortTitle, LognTitle, ArticleContent, \r\n      LinkUrl, TitleLength, PicUrl, IncludePic, InputTime, UpdateTime, Hits, Editor, Elite, \r\n      ArticleUserID, Validay, Status, ArticleID, SpecialID, OnTop\r\nFROM HLShop_IndexArticle\r\nWHERE ArticleType=@ArticleType AND OnTop=1 AND Elite=1\r\nORDER BY ArticleID DESC";
			this._commandCollection[7].CommandType = CommandType.Text;
			this._commandCollection[7].Parameters.Add(new SqlParameter("@ArticleType", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "ArticleType", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8] = new SqlCommand();
			this._commandCollection[8].Connection = this.Connection;
			this._commandCollection[8].CommandText = "SELECT ArticleContent, ArticleID, ArticleType, ArticleUserID, ChannelID, ClassID, Editor, Elite, Hits, IncludePic, InputTime, LinkUrl, LognTitle, OnTop, PicUrl, ShortTitle, SpecialID, Status, TitleLength, TitleType, UpdateTime, Validay FROM HLShop_IndexArticle WHERE (ChannelID = @ChannelID) AND (ClassID = @ClassID) AND (OnTop = 1) AND (Status = 3) ORDER BY ArticleID DESC";
			this._commandCollection[8].CommandType = CommandType.Text;
			this._commandCollection[8].Parameters.Add(new SqlParameter("@ChannelID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ChannelID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9] = new SqlCommand();
			this._commandCollection[9].Connection = this.Connection;
			this._commandCollection[9].CommandText = "PR_Edit";
			this._commandCollection[9].CommandType = CommandType.StoredProcedure;
			this._commandCollection[9].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@strSQL", SqlDbType.VarChar, 1000, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[10] = new SqlCommand();
			this._commandCollection[10].Connection = this.Connection;
			this._commandCollection[10].CommandText = "UPDATE [HLShop_IndexArticle] SET  [Hits] = Hits+1 WHERE (([ArticleID] = @ArticleID))";
			this._commandCollection[10].CommandType = CommandType.Text;
			this._commandCollection[10].Parameters.Add(new SqlParameter("@ArticleID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ArticleID", DataRowVersion.Original, false, null, "", "", ""));
		}
		[DataObjectMethod(DataObjectMethodType.Select, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_IndexArticle.HLShop_IndexArticleDataTable GetAllIndexArticle()
		{
			this.Adapter.SelectCommand = this.CommandCollection[0];
			S_IndexArticle.HLShop_IndexArticleDataTable hLShop_IndexArticleDataTable = new S_IndexArticle.HLShop_IndexArticleDataTable();
			this.Adapter.Fill(hLShop_IndexArticleDataTable);
			return hLShop_IndexArticleDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_IndexArticle.HLShop_IndexArticleDataTable GetAdminIndexArticle(string tblName, string strGetFields, string fldName, int? PageSize, int? PageIndex, int? OrderType, string strWhere, int? Counts)
		{
			this.Adapter.SelectCommand = this.CommandCollection[2];
			if (tblName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = tblName;
			}
			if (strGetFields == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = strGetFields;
			}
			if (fldName == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = fldName;
			}
			if (PageSize.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = PageSize.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (PageIndex.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = PageIndex.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (OrderType.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[6].Value = OrderType.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[6].Value = System.DBNull.Value;
			}
			if (strWhere == null)
			{
				this.Adapter.SelectCommand.Parameters[7].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[7].Value = strWhere;
			}
			if (Counts.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[8].Value = Counts.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[8].Value = System.DBNull.Value;
			}
			S_IndexArticle.HLShop_IndexArticleDataTable hLShop_IndexArticleDataTable = new S_IndexArticle.HLShop_IndexArticleDataTable();
			this.Adapter.Fill(hLShop_IndexArticleDataTable);
			return hLShop_IndexArticleDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_IndexArticle.HLShop_IndexArticleDataTable GetArticleByArticleID(int ArticleID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[3];
			this.Adapter.SelectCommand.Parameters[0].Value = ArticleID;
			S_IndexArticle.HLShop_IndexArticleDataTable hLShop_IndexArticleDataTable = new S_IndexArticle.HLShop_IndexArticleDataTable();
			this.Adapter.Fill(hLShop_IndexArticleDataTable);
			return hLShop_IndexArticleDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_IndexArticle.HLShop_IndexArticleDataTable GetArticleByModuleID(int? ChannelID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[4];
			if (ChannelID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ChannelID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_IndexArticle.HLShop_IndexArticleDataTable hLShop_IndexArticleDataTable = new S_IndexArticle.HLShop_IndexArticleDataTable();
			this.Adapter.Fill(hLShop_IndexArticleDataTable);
			return hLShop_IndexArticleDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_IndexArticle.HLShop_IndexArticleDataTable GetArticleByModuleIDSpecialID(int? ChannelID, int? SpecialID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[5];
			if (ChannelID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ChannelID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (SpecialID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = SpecialID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			S_IndexArticle.HLShop_IndexArticleDataTable hLShop_IndexArticleDataTable = new S_IndexArticle.HLShop_IndexArticleDataTable();
			this.Adapter.Fill(hLShop_IndexArticleDataTable);
			return hLShop_IndexArticleDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_IndexArticle.HLShop_IndexArticleDataTable GetArticleByTypeSpecialID(int? SpecialID, string ArticleType)
		{
			this.Adapter.SelectCommand = this.CommandCollection[6];
			if (SpecialID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = SpecialID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (ArticleType == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ArticleType;
			}
			S_IndexArticle.HLShop_IndexArticleDataTable hLShop_IndexArticleDataTable = new S_IndexArticle.HLShop_IndexArticleDataTable();
			this.Adapter.Fill(hLShop_IndexArticleDataTable);
			return hLShop_IndexArticleDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_IndexArticle.HLShop_IndexArticleDataTable GetIndexArticle(string ArticleType)
		{
			this.Adapter.SelectCommand = this.CommandCollection[7];
			if (ArticleType == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ArticleType;
			}
			S_IndexArticle.HLShop_IndexArticleDataTable hLShop_IndexArticleDataTable = new S_IndexArticle.HLShop_IndexArticleDataTable();
			this.Adapter.Fill(hLShop_IndexArticleDataTable);
			return hLShop_IndexArticleDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_IndexArticle.HLShop_IndexArticleDataTable GetOnTopArticleByChannelIDClassID(int? ChannelID, int? ClassID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[8];
			if (ChannelID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ChannelID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (ClassID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ClassID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			S_IndexArticle.HLShop_IndexArticleDataTable hLShop_IndexArticleDataTable = new S_IndexArticle.HLShop_IndexArticleDataTable();
			this.Adapter.Fill(hLShop_IndexArticleDataTable);
			return hLShop_IndexArticleDataTable;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(S_IndexArticle.HLShop_IndexArticleDataTable dataTable)
		{
			return this.Adapter.Update(dataTable);
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(S_IndexArticle dataSet)
		{
			return this.Adapter.Update(dataSet, "HLShop_IndexArticle");
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow dataRow)
		{
			return this.Adapter.Update(new DataRow[]
			{
				dataRow
			});
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow[] dataRows)
		{
			return this.Adapter.Update(dataRows);
		}
		[DataObjectMethod(DataObjectMethodType.Insert, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int AddNewArticle(int? ChannelID, int? ClassID, string ArticleType, int? TitleType, string ShortTitle, string LognTitle, string ArticleContent, string LinkUrl, int? TitleLength, string PicUrl, int? IncludePic, System.DateTime? InputTime, System.DateTime? UpdateTime, int? Hits, string Editor, int? OnTop, int? Elite, int? ArticleUserID, int? Validay, int? Status, int? SpecialID, string TemplatePath)
		{
			SqlCommand sqlCommand = this.CommandCollection[1];
			if (ChannelID.HasValue)
			{
				sqlCommand.Parameters[0].Value = ChannelID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (ClassID.HasValue)
			{
				sqlCommand.Parameters[1].Value = ClassID.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (ArticleType == null)
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = ArticleType;
			}
			if (TitleType.HasValue)
			{
				sqlCommand.Parameters[3].Value = TitleType.Value;
			}
			else
			{
				sqlCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (ShortTitle == null)
			{
				sqlCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[4].Value = ShortTitle;
			}
			if (LognTitle == null)
			{
				sqlCommand.Parameters[5].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[5].Value = LognTitle;
			}
			if (ArticleContent == null)
			{
				sqlCommand.Parameters[6].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[6].Value = ArticleContent;
			}
			if (LinkUrl == null)
			{
				sqlCommand.Parameters[7].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[7].Value = LinkUrl;
			}
			if (TitleLength.HasValue)
			{
				sqlCommand.Parameters[8].Value = TitleLength.Value;
			}
			else
			{
				sqlCommand.Parameters[8].Value = System.DBNull.Value;
			}
			if (PicUrl == null)
			{
				sqlCommand.Parameters[9].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[9].Value = PicUrl;
			}
			if (IncludePic.HasValue)
			{
				sqlCommand.Parameters[10].Value = IncludePic.Value;
			}
			else
			{
				sqlCommand.Parameters[10].Value = System.DBNull.Value;
			}
			if (InputTime.HasValue)
			{
				sqlCommand.Parameters[11].Value = InputTime.Value;
			}
			else
			{
				sqlCommand.Parameters[11].Value = System.DBNull.Value;
			}
			if (UpdateTime.HasValue)
			{
				sqlCommand.Parameters[12].Value = UpdateTime.Value;
			}
			else
			{
				sqlCommand.Parameters[12].Value = System.DBNull.Value;
			}
			if (Hits.HasValue)
			{
				sqlCommand.Parameters[13].Value = Hits.Value;
			}
			else
			{
				sqlCommand.Parameters[13].Value = System.DBNull.Value;
			}
			if (Editor == null)
			{
				sqlCommand.Parameters[14].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[14].Value = Editor;
			}
			if (OnTop.HasValue)
			{
				sqlCommand.Parameters[15].Value = OnTop.Value;
			}
			else
			{
				sqlCommand.Parameters[15].Value = System.DBNull.Value;
			}
			if (Elite.HasValue)
			{
				sqlCommand.Parameters[16].Value = Elite.Value;
			}
			else
			{
				sqlCommand.Parameters[16].Value = System.DBNull.Value;
			}
			if (ArticleUserID.HasValue)
			{
				sqlCommand.Parameters[17].Value = ArticleUserID.Value;
			}
			else
			{
				sqlCommand.Parameters[17].Value = System.DBNull.Value;
			}
			if (Validay.HasValue)
			{
				sqlCommand.Parameters[18].Value = Validay.Value;
			}
			else
			{
				sqlCommand.Parameters[18].Value = System.DBNull.Value;
			}
			if (Status.HasValue)
			{
				sqlCommand.Parameters[19].Value = Status.Value;
			}
			else
			{
				sqlCommand.Parameters[19].Value = System.DBNull.Value;
			}
			if (SpecialID.HasValue)
			{
				sqlCommand.Parameters[20].Value = SpecialID.Value;
			}
			else
			{
				sqlCommand.Parameters[20].Value = System.DBNull.Value;
			}
			if (TemplatePath == null)
			{
				sqlCommand.Parameters[21].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[21].Value = TemplatePath;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int PR_Edit(string strSQL)
		{
			SqlCommand sqlCommand = this.CommandCollection[9];
			if (strSQL == null)
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = strSQL;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateArticleHits(int ArticleID)
		{
			SqlCommand sqlCommand = this.CommandCollection[10];
			sqlCommand.Parameters[0].Value = ArticleID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
	}
}
